package com.jic.member.mapper;

import java.lang.Long;
import java.util.List;

import com.jic.member.entity.MememberGrade;
import com.jic.member.request.MemberGradeRequest;
import com.jic.member.response.MemberGradeResponse;
import com.jic.member.response.MememberGradeResponse;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * 会员等级表
 * @author : 
 * @email : 
 * @since : 2020-04-03 02:09:28
 * @version : v1.0.0
 */
@Mapper
public interface  MememberGradeMapper {

    long insert(MememberGrade mememberGrade);

    long delete(Long id);

    long update(MememberGrade mememberGrade);

    MememberGrade queryByPrimaryKey(Long id);

    List<MememberGrade> query(MememberGrade mememberGrade);

    List<MemberGradeResponse> queryPage(@Param("startIndex") int startIndex, @Param("limit") int limit, @Param("mememberGrade") MemberGradeRequest mememberGrade);

    long queryPageCount(@Param("mememberGrade") MemberGradeRequest mememberGrade);

    List<MememberGrade> queryByInterval(MememberGrade mememberQuery);

    List<MememberGrade> queryInDeptArry(@Param("deptIds") String[] deptIds);

    List<MemberGradeResponse> queryStoreGrade(@Param("startIndex")int startIndex, @Param("limit")int limit, @Param("mememberGrade")MemberGradeRequest mememberGrade);

    long queryStoreGradeCount(@Param("mememberGrade")MemberGradeRequest mememberGrade);

    List<MememberGradeResponse> queryInIds(@Param("ids") List<Long> ids);

    MememberGrade queryMaxGradeByDeptId();

    MememberGrade queryMinGradeByDeptId();

}